﻿CREATE PROCEDURE [dbo].[check_user]
	@in_username nvarchar(20), 
	@in_password nvarchar(20),
	@out_userrole nvarchar(20) output
AS
	select @out_userrole = users_role from tb_users where users_name = @in_username and users_password = @in_password;